SYD (cost, salvage, life, period)

Basic and Crystal syntax.

Arguments
Returns

Number value

Action

SYD returns a Number specifying the sum-of-years' digits depreciation of an asset for a single period.

Examples

The following examples are applicable to both Basic and Crystal syntax:

Suppose a company purchases a fleet of cars for $500,000. The cars have a lifetime of 10 years and a salvage value of $60,000. They are depreciated as follows:

SYD (500000, 60000, 10, 1)

Returns 80000. The first year's depreciation is $80,000.

SYD (500000, 60000, 10, 4)

Returns 56000. The fourth year's depreciation is $56,000.

SYD (500000, 60000, 10, 10)

Returns 8000. The final year's depreciation is $8,000.

Comment

This function is designed to work like the Visual Basic function of the same name.



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com